Gestor 48jNAsZKQ6jifu3w6XglJ9VU9YrVSuMdy12xzGQlY0/HePtIT0/TyMND/czqAHdnw9bjK8lnewntE+Gt4gT1RvHe469VV/Pla1qlpWps4D+DcNkJyVRBvEVQ+exkPWILwsibaEs= Gestor config nome_fantasia,System.String cnpj_cpf,System.String logradouro,System.String numero,System.String bairro,System.String uf,System.String telefone,System.String vendedor,System.String razao_social,System.String cidade,System.String ie_rg,System.String imagem_logo,System.Byte[] 30 False config Gestor select c.razao_social, c.nome_fantasia, c.cnpj_cpf, c.logradouro, c.numero, c.bairro, c.uf, c.telefone, cidade.nome as cidade, c.ie_rg, c.imagem_logo from configuracao c left join cidade on cidade.id = c.cidade_id dados orcamento,System.String nome_fantasia,System.String data_emissao,System.DateTime valor_documento,System.Decimal mes_baixa,System.Int64 data,System.DateTime valor,System.Decimal avista,System.Int64 percentual_baixa,System.Decimal comissao,System.Decimal nome_vendedor,System.String total_produtos,System.Decimal cliente,System.String receber_id,System.Int32 orcamento_id,System.Int32 30 False dados Gestor select orc.id as orcamento_id, rec.id AS receber_id, LPAD(orc.id, 6, '0') as orcamento, cor.nome_fantasia AS cliente, orc.total_produtos, cor.nome_fantasia, rec.data_emissao, rec.valor_documento, month(baixa.data) as mes_baixa, baixa.data, 0 AS valor, 0 AS avista, 0 AS percentual_baixa, 1 AS comissao, concat(vendedor.id, ' - ', vendedor.nome_fantasia) as nome_vendedor from receber_baixa baixa inner join receber rec on rec.id = baixa.receber_id inner join orcamento orc on orc.id = rec.orcamento_id left join correntista vendedor on vendedor.id = orc.vendedor_id inner join correntista cor on cor.id = orc.cliente_id where vendedor.id = {funcionario_id} AND DATE_FORMAT(CAST(baixa.data as DATE), '%Y-%m-%d') BETWEEN DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') group by orc.id funcionario id,System.Int32 tipo_pessoa,System.String nome_fantasia,System.String razao_social,System.String contato,System.String data_nascimento,System.DateTime cep,System.String endereco,System.String numero,System.String bairro,System.String uf,System.String cpf_cnpj,System.String rg_ie,System.String telefone,System.String celular,System.String fax,System.String email,System.String limite_credito,System.Decimal data_cadastro,System.DateTime observacoes,System.String cliente,System.Boolean funcionario,System.Boolean fornecedor,System.Boolean estado_civil,System.String inativo,System.Boolean usuario,System.String senha,System.String liberador,System.Boolean seq_sincronizacao,System.Int64 codigo_retaguarda,System.String fun_limite_desconto,System.Decimal ddd_telefone,System.String ddd_celular,System.String limite_credito_utilizado,System.Decimal limite_credito_saldo,System.Decimal complemento,System.String inscricao_municipal,System.String filiacao_mae,System.String filiacao_pai,System.String conjuge_nome,System.String conjuge_telefone,System.String conjuge_celular,System.String conjuge_local_trabalho,System.String trabalho_empresa,System.String trabalho_cargo,System.String trabalho_data_admissao,System.DateTime trabalho_renda,System.Decimal senha_venda,System.String nao_contribuinte_icms,System.Boolean bairro_id,System.Int32 cidade_id,System.Int32 grupo_usuario_id,System.Int32 grupo_correntista_id,System.Int32 codigo_ibge_temp,System.String codigo_temp,System.String sexo_temp,System.String ie_produtor_rural,System.String pais_id,System.Int32 codigo_geral,System.String id_cliente_temp,System.String 30 False funcionario Gestor select * from correntista where funcionario = 1 baixa id,System.Int32 data,System.DateTime valor,System.Decimal hora,System.String receber_id,System.Int32 titulo_id,System.Int32 movimento_id,System.Int32 baixa_id,System.Int32 funcionario_id,System.Int32 historico,System.String valor_credito,System.Decimal orcamento_id,System.Int32 data_baixa,System.DateTime valor_baixa,System.Decimal ordem,System.Int64 _x0040_orcamento_x0020_:_x003D__x0020_orcamento_id,System.Int64 valor_baixa1,System.Decimal comissao,System.Decimal avista,System.Int32 30 False baixa Gestor SELECT data_baixa, valor_baixa, titulo_id, orcamento_id, @rownum := CASE WHEN @orcamento = orcamento_id THEN @rownum + 1 ELSE 1 END AS ordem, @orcamento := orcamento_id, valor_baixa, comissao, avista FROM (SELECT @orcamento := 0, @rownum := 0) AS inicializacao, (select baixa.data as data_baixa, baixa.valor as valor_baixa, baixa.titulo_id, orc.id as orcamento_id, case when baixa.data = rec.data_emissao then 1 else 0 end as avista, ( select sum( ((item.valor_liquido * (case when avista then prod.comissao_vista else prod.comissao_prazo end) / 100) * ((sum(baixa.valor) / orc.valor_liquido) * 100)) / 100 ) from orcamento_item item inner join produto prod on prod.id = item.produto_id where item.orcamento_id = orc.id ) as comissao from (SELECT @orcamento := 0) AS inicializacao, receber_baixa baixa inner join receber rec on rec.id = baixa.receber_id inner join orcamento orc on orc.id = rec.orcamento_id left join correntista vendedor on vendedor.id = orc.vendedor_id inner join correntista cor on cor.id = orc.cliente_id where vendedor.id = {funcionario_id} AND DATE_FORMAT(CAST(baixa.data as DATE), '%Y-%m-%d') BETWEEN DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') group by baixa.id order by orc.id) AS tab1 relBaixa orcamento_id False relBaixa relBaixa orcamento_id ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,vendedor_id,vendedor_id,System.Int32,_x0030_,False,False ,data_inicial,data_inicial,System.String,_x0032_016-03-01,False,False ,data_final,data_final,System.String,_x0032_016-03-31,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,Data,Data,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0038__x005F_x002F_13_x005F_x002F_2018_x005F_x0020_5:05:43_x005F_x0020_PM_x002C__x005F_x0038__x005F_x002F_13_x005F_x002F_2018_x005F_x0020_5:05:43_x005F_x0020_PM,False,False ,funcionario_id,funcionario_id,System.Int32,_x0030_,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.9,19,0.8 Transparent 15.4,0.1,3.6,0.4 Arial,10 Right 0,0,0,0 Text3 {PageNofMThrough} Black Transparent 0,0.1,8.4,0.6 Arial,8 0,0,0,0 Text21 Kinyx Gestor v.{versao} - www.kinyx.com.br Black Expression PageFooterBand1 Transparent 0,0.4,19,4.2 Transparent 0,3.6,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 6aa5f4c980424a969091ce71aa8350e9 0,0,0,0 Text7 Orçamento Black Expression Center GlassBrush,Gainsboro,True,0.2 0,2.2,19,0.8 Transparent 0.2,0.1,18.6,0.6 Tahoma,14.25,Bold,Point,False,0 b477fa6ca8314ffa84101e90adebd93d Center 0,0,0,0 Text1 COMISSÃO POR PARCELA Black Expression 5ec57d6d6fbe4b22832fe900eedd309a Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 e3190c0b3e734bae98aaceae2c9ffb0f 0,0,0,0 Text4 {config.razao_social} Black Expression Transparent 2.2,0.4,13.6,1.8 Tahoma,9,Regular,Point,False,0 4e7cbdc300ca4665802434919c3f2389 0,0,0,0 Text14 CNPJ: {config.cnpj_cpf} - IE: {config.ie_rg} End.: {config.logradouro}, {config.numero} Bairro: {config.bairro} {config.cidade}/{config.uf} Black Expression Transparent 13.6,0.2,5.4,0.6 Tahoma,8.25,Bold,Point,False,0 bffdaccca0f24554a72a6fec6963f170 Right 0,0,0,0 Text2 {Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm")} Black Expression Transparent 15.8,0.6,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 4bc9fbfe1a76416ca43ed1d751c7b3dc Right 0,0,0,0 Text5 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 config.imagem_logo 4de07384d7b7483a9f15ace801a7cd10 imgLogo True Transparent 0,3,9.6,0.6 Tahoma,8.25,Bold,Point,False,0 e28baa4eb74e43088c2bb843fee4bff4 0,0,0,0 Text44 Funcionário: {dados.nome_vendedor} Black Expression Center Transparent 17,3,2,0.6 Tahoma,8.25,Bold,Point,False,0 1922ab82129d446584889487b6df9c1c Right 0,0,0,0 Text16 {Data.ToDate.Date} Black Expression Center Transparent 12.4,3,3.6,0.6 Tahoma,8.25,Bold,Point,False,0 f80d7580f5a9451d84f2ae9f753e61ac Right 0,0,0,0 Text20 {Data.FromDate.Date} Black Expression Center Transparent 16,3,1,0.6 Tahoma,8.25,Bold,Point,False,0 4131f614132a43bd8e7ff26b3fc13f93 Center 0,0,0,0 Text24 até Black Expression Center ReportTitleBand1 Transparent 0,5.4,19,1.4 Transparent 0,0,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 5194f3bb493b471782acbf20621abd71 0,0,0,0 Text26 Orçamento Black Expression Center Transparent 2.2,0,2.2,0.6 Tahoma,8.25,Regular,Point,False,0 905fa97b1f894f77b7f8bdfed60f6f96 0,0,0,0 Text27 {dados.orcamento} Black Expression Center Transparent 4.4,0,1.2,0.6 Tahoma,8.25,Bold,Point,False,0 7c7db95f5a7c4550ad0cd9026aae8930 0,0,0,0 Text6 Cliente: Black Expression Center Transparent 5.6,0,13.4,0.6 Tahoma,8.25,Regular,Point,False,0 f6b6eb8ac266473e8db59b30b31394f2 0,0,0,0 Text9 {dados.cliente} Black DataColumn Center Transparent 0,0.4,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 25b3e00199a9436da49eb6fa22d15ea8 0,0,0,0 Text8 Data venda: Black Expression Center Transparent 2.2,0.4,2.2,0.6 Tahoma,8.25,Regular,Point,False,0 370d957aae4747f5aec6969808496bbe 0,0,0,0 Text18 {dados.data_emissao} Black DataColumn Center Transparent 4.4,0.4,2,0.6 Tahoma,8.25,Bold,Point,False,0 d11c387559eb446789ad6bf9c0dccac2 0,0,0,0 Text15 Valor Venda: Black Expression Center Transparent 6.4,0.4,2.6,0.6 Tahoma,8.25,Regular,Point,False,0 5616320a93cc47beb3d7fc99231bcfed 0,0,0,0 Text19 {dados.total_produtos} Black , . 9 2 R$ DataColumn Center Transparent 14.2,1,2.2,0.4 Tahoma,8.25,Bold,Point,False,0 744fd17fe4fc4c20b50bc94cb8095ac4 Right 0,0,0,0 Text10 Valor Parcela Black Expression Center Transparent 16.6,1,2.4,0.4 Tahoma,8.25,Bold,Point,False,0 60edbc88256f47188dd1a617cf1bfce7 Right 0,0,0,0 Text12 Valor Comissão Black Expression Center Transparent 0.4,1,2.6,0.4 Tahoma,8.25,Bold,Point,False,0 f04b7ccb17274bf4831bfd2f3822703f 0,0,0,0 Text17 Parcela Black Expression Center Transparent 9,0.4,2,0.6 Tahoma,8.25,Bold,Point,False,0 036425dd427944e5ad12365b7e73e47f 0,0,0,0 Text28 Comissão: Black Expression Center Transparent 11,0.4,2.6,0.6 Tahoma,8.25,Regular,Point,False,0 e09bedeab66c430aaaa06cdd69c1e4dd 0,0,0,0 Text29 {Sum(DataBand2,baixa.comissao)} Black , . 9 2 R$ Totals Center 0,0,19,0.0254 Black Black 508ce17a18774317ae7501365e7fd9f3 HorizontalLinePrimitive2 Black {dados.orcamento} GroupHeaderBand1 Transparent 0,7.6,19,0 dados comissao,GreaterThan,_x0030_,,Numeric DataBand1 ASC orcamento_id Transparent 0,8.4,19,0.4 Transparent 0.4,0,11.2,0.4 Tahoma,8.25,Regular,Point,False,0 2dd9aa7c466c4122919acc3fe019733e 0,0,0,0 Text25 {String.Format("Parcela {0} de {1}", baixa.ordem, Count(DataBand2))} Black Expression Center Transparent 16.6,0,2.4,0.4 Tahoma,8.25,Regular,Point,False,0 d7de0daf6fb54c1aa02d8a1948bd9972 Right 0,0,0,0 Text13 {baixa.comissao} Black , . 1 0 R$ Expression Center Transparent 14,0,2.4,0.4 Tahoma,8.25,Regular,Point,False,0 c5fa1c8e56654933ac7eebdfe9070b02 Right 0,0,0,0 Text22 {baixa.valor_baixa} Black , . 1 0 R$ DataColumn Center relBaixa baixa DataBand2 True ASC orcamento_id Transparent 0,9.6,19,1.6 Transparent 0,0,2.8,0.6 Tahoma,8.25,Bold,Point,False,0 d96c709d6edc48cabfb510eb0750af4b 0,0,0,0 Text11 Total de comissão: Black Expression Center Transparent 2.8,0,3.8,0.6 Tahoma,8.25,Regular,Point,False,0 fc21a38b13a643ef90f1516ba88ddd66 0,0,0,0 Text23 {SumRunning(DataBand2,baixa.comissao)} Black , . 9 2 R$ Totals Center 0,0,19,0.0254 Black Black HorizontalLinePrimitive1 Black ReportSummaryBand1 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] Control Window 24,48,96,20 Microsoft Sans Serif,8 Black Short 44dbb8891ae947eb868e6e318f58522c 24, 48 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM dtInicial 96, 20 2/6/2018 4:30:02 PM Window 160,48,96,20 Microsoft Sans Serif,8 Black Short 3c782d4b80514954997c098abb36c123 160, 48 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM dtFinal 96, 20 2/6/2018 4:30:08 PM Control 24,24,96,24 Microsoft Sans Serif,8 Black 43da8f65be6f4108a7a0596d0325402a 24, 24 LabelControl1 96, 24 Data Inicial Control 160,24,96,24 Microsoft Sans Serif,8 Black 1fe8aeb8a6734445b909848fbd2101a4 160, 24 LabelControl2 96, 24 Data Final 24,168,96,24 Cancel Microsoft Sans Serif,8 Black deb367707b034b328af1f1fe786ca8cb 24, 168 btnCancelar 96, 24 Cancelar Data.From = dtInicial.Value; Data.To = dtFinal.Value; int.TryParse(txtFuncionario.SelectedValue.ToString(), out funcionario_id); 160,168,96,24 OK Microsoft Sans Serif,8 Black bec8be4d22bc4e699efbc59fcdddfe6e 160, 168 btnGerar 96, 24 Gerar Window 24,128,232,20 Microsoft Sans Serif,8 Black f570008a92f7445589e1587719e6f853 24, 128 txtFuncionario 232, 20 Control 24,112,96,16 Microsoft Sans Serif,8 Black 8b783cae4ec645728fc1b82203c6231b 24, 112 LabelControl3 96, 16 Funcionário Microsoft Sans Serif,8 085a40e77afb4c0ba6124cf1f7a823c1 txtFuncionario.Control.Items.Clear(); txtFuncionario.Control.DisplayMember = "nome_fantasia"; txtFuncionario.Control.ValueMember = "id"; txtFuncionario.Control.DataSource = this.Dictionary.DataSources["funcionario"].DataTable; 0, 0 Form1 304, 232 Informe o periodo System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 11/19/2018 5:11:50 PM 9/25/2015 9:37:43 PM c8eba3106b7749e1a3915b27d64277c7 Report Centimeters 2015.1.0 CSharp